﻿CREATE proc treeedittest    
@MaNhom as int    
as    
select a.MenuID,a.MenuCha,a.ThuTuXuatHien ,b.TenMenu ,b.Hinh as Icon    
from QuanTri_PhanNhomMenu a,DanhMuc_Menu b    
Where a.MenuID=b.MenuID and a.MaNhomMenuND=@MaNhom
order by a.ThuTuXuatHien